package com.blacksheep.mtm.dao;

import com.blacksheep.mtm.pojo.manager.TbBindBox;
import com.blacksheep.mtm.pojo.manager.TbBindBoxExample;
import java.util.List;
import org.apache.ibatis.annotations.Param;

public interface TbBindBoxMapper {

    long countByExample(TbBindBoxExample example);

    int deleteByExample(TbBindBoxExample example);

    int deleteByPrimaryKey(Integer id);

    int insert(TbBindBox record);

    int insertSelective(TbBindBox record);

    List<TbBindBox> selectByExample(TbBindBoxExample example);

    TbBindBox selectByPrimaryKey(Integer id);

    int updateByExampleSelective(@Param("record") TbBindBox record, @Param("example") TbBindBoxExample example);

    int updateByExample(@Param("record") TbBindBox record, @Param("example") TbBindBoxExample example);

    int updateByPrimaryKeySelective(TbBindBox record);

    int updateByPrimaryKey(TbBindBox record);

    int alertStateById(@Param("id") int id,@Param("state") int state);


    List<TbBindBox> selectList(@Param("search") String search, @Param("state") int[] state, @Param("minDate") String minDate,
                                @Param("maxDate") String maxDate, @Param("orderCol") String orderCol,
                                @Param("orderDir") String orderDir);

    TbBindBox selectOneByDeviceCode(String code);

    int updateRemarkById(@Param("id") int id,@Param("remark") String remark);
}